d9a123fc2df999e2c3741e731e5118224b871e41,src/main/java/applets/etsmtl/ca/news/db/NouvellesDAO.java,NouvellesDAO,find,#String#,17
Before Change
public Nouvelle find(String id) {
try {
ResultSet result = this.connection
.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY
).executeQuery(
"SELECT * FROM nouvelles WHERE id = '" +id+"'"
);
if(result.first()) {
return getDataFromResult(result);
}
After Change
public class NouvellesDAO extends DAO<Nouvelle> {
@Override
public Nouvelle find(String id) {
try {
String findById = "SELECT * FROM nouvelles WHERE id = ?";
PreparedStatement st = this.connection.prepareStatement(findById,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
st.setString(1, id);
ResultSet result = st.executeQuery();
if(result.first()) {
Nouvelle nouvelle = getDataFromResult(result);
result.close();
st.close();
return nouvelle;
}